package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the PS_PROJ_PLAN_BUDGET database table.
 * 
 */
@Entity
@Table(name="PS_PROJ_PLAN_BUDGET")
@NamedQueries({
    @NamedQuery(name = "PsProjPlanBudget.findAll", query = " SELECT c FROM PsProjPlanBudget c "),
    @NamedQuery(name = "PsProjPlanBudget.findById", query = " SELECT c FROM PsProjPlanBudget c WHERE  c.promisStagingId = :Id "),
    @NamedQuery(name = "PsProjPlanBudget.findByInstanceNo", query = " SELECT c FROM PsProjPlanBudget c WHERE  c.instanceNo = :instanceNo "),
    @NamedQuery(name = "PsProjPlanBudget.findAllIsSync", query = " SELECT c FROM PsProjPlanBudget c WHERE c.issync = :issync order by c.instanceNo asc")
    })
public class PsProjPlanBudget extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID")
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER")
	private String actionHandler;

	@Column(name="ACTIVITY_GROUP")
	private String activityGroup;

	@Column(name="BUILDING_PHASE")
	private String buildingPhase;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;

	private String currency;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	private String isactive;

	private String issync;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	private String status;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TOTAL_BUDGET")
	private String totalBudget;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;
	
	@Column(name="SAP_COMPANY_CODE", length=4)
	private String sapCompanyCode;
	
	@Column(name="BUDGET_CODE" , length=100)	
	private String budgetCode;
	
	@Column(name="ACTIVITY_GROUP_CODE", length=100)
	private String activityGroupCode;
	
	@Column(name="DOCUMENT_NO")
	private String documentNo;
	
	@Column(name="REVISION")
	private String revision;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;
	
	@Column(name="BUILDING_ALL_FLAG")
	private String buildingAllFlag;
	
    /**
	 * @return the buildingAllFlag
	 */
	public String getBuildingAllFlag() {
		return buildingAllFlag;
	}

	/**
	 * @param buildingAllFlag the buildingAllFlag to set
	 */
	public void setBuildingAllFlag(String buildingAllFlag) {
		this.buildingAllFlag = buildingAllFlag;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
	
    /**
	 * @return the revision
	 */
	public String getRevision() {
		return revision;
	}

	/**
	 * @param revision the revision to set
	 */
	public void setRevision(String revision) {
		this.revision = revision;
	}

	/**
	 * @return the documentNo
	 */
	public String getDocumentNo() {
		return documentNo;
	}

	/**
	 * @param documentNo the documentNo to set
	 */
	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

	/**
	 * @return the budgetCode
	 */
	public String getBudgetCode() {
		return budgetCode;
	}

	/**
	 * @param budgetCode the budgetCode to set
	 */
	public void setBudgetCode(String budgetCode) {
		this.budgetCode = budgetCode;
	}

	/**
	 * @return the activityGroupCode
	 */
	public String getActivityGroupCode() {
		return activityGroupCode;
	}

	/**
	 * @param activityGroupCode the activityGroupCode to set
	 */
	public void setActivityGroupCode(String activityGroupCode) {
		this.activityGroupCode = activityGroupCode;
	}

	/**
	 * @return the sapCompanyCode
	 */
	public String getSapCompanyCode() {
		return sapCompanyCode;
	}

	/**
	 * @param sapCompanyCode the sapCompanyCode to set
	 */
	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public PsProjPlanBudget() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getActivityGroup() {
		return this.activityGroup;
	}

	public void setActivityGroup(String activityGroup) {
		this.activityGroup = activityGroup;
	}

	public String getBuildingPhase() {
		return this.buildingPhase;
	}

	public void setBuildingPhase(String buildingPhase) {
		this.buildingPhase = buildingPhase;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTotalBudget() {
		return this.totalBudget;
	}

	public void setTotalBudget(String totalBudget) {
		this.totalBudget = totalBudget;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}